SortCommand Constructor(IRange,Int32[],SortOn[],Object[],SortOrder[],Boolean,Boolean,SortOrientation,Boolean)
In This Topic
Sort by multi-conditions
Syntax
'Declaration
Public Function New( _
ByVal As IRange, _
ByVal columnIndex() As Integer, _
ByVal () As SortOn, _
ByVal () As Object, _
ByVal () As SortOrder, _
Optional ByVal As Boolean, _
Optional ByVal As Boolean, _
Optional ByVal As SortOrientation, _
Optional ByVal As Boolean _
)
'Usage
Dim range As IRange
Dim columnIndex() As Integer
Dim sortOn() As SortOn
Dim sortValue() As Object
Dim sortOrder() As SortOrder
Dim replace As Boolean
Dim matchCase As Boolean
Dim sortOrientation As SortOrientation
Dim hasHeader As Boolean
Dim instance As New SortCommand(range, columnIndex, sortOn, sortValue, sortOrder, replace, matchCase, sortOrientation, hasHeader)
Parameters
- range
- columnIndex
- sortOn
- sortValue
- sortOrder
- replace
- matchCase
- sortOrientation
- hasHeader
See Also